Entity DefinitionLogical Name : WorkerTimeAccrualHistory |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| WorkerID (FK)(PK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
| ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
| WorkerAccrualTypeCode (FK)(PK) | A unique retailer assigned code denoting the kind of time that is being recorded. e.g. Regular, Overtime, Premium, PremiumOvertime, Holiday, PaidHoliday, Vacation, SickTime, Bereavement. | CD_TYP_WRKR_TM | Code4 | char(4) | WorkerTimeAccrualType(CO_TYP_WRKR_TM) |
| AccrualQuantity | The number of Hours worked by the Worker during the nominated ReportingPeriod delineated by the nominated AccrualType | QU_UN_CNT | Quantity | DECIMAL(9,3) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| ReportingPeriod | delineates | WorkerTimeAccrualHistory |
| WorkerTimeAccrualType | classifies | WorkerTimeAccrualHistory |
| Worker | is tracked by | WorkerTimeAccrualHistory |
| Logical View |
|---|
| Logical 03000 - Reporting - Macro View |
| Logical 03000 - Reporting - Macro View |
| Logical 11150 - Worker - Time Punch View |